Reports, Opening Balance Issues

[davidonelson]

PART 1: System Reports / Customer / Detail Reports / Customer Opening Balance

The report is currently grouped by:

• Bill To Name, with subtotal (good)
• Transaction Type, with subtotal (good)

The report is currently sorted by:

• Invoice Date (good)

Problems that need to be fixed:

• A grand total needs to be added to the report because you can't balance to your legacy system grand total.
• The CustomerCode and the CustomerLegacyCode needs to be added to the report in addition to the Bill To Name because when you are converting to CB, you need these data items so you can find and research the customers out of balance.

PART 2: System Reports / Supplier / Detail Reports / Supplier Opening Balance

The report is currently grouped by:

• Supplier Name (good), without subtotal (bad)
• Transaction type (good), with subtotal (good)

Problems that need to be fixed:

• A grand total needs to be added to the report because you can't balance to your legacy system grand total.
• A subtotal needs to be added for the Supplier Name group so you can balance the supplier
• The SupplierCode and SupplierLegacyCode needs to be added so you can find and research customers out of balance

[ramildomingo]

Hello @davidonelson. Can you elaborate more on the following please?

Suppler does Groups by type (credit/invoice) subtotal by type, no subtotal for the supplier, can't balance to customer total on input need to group by supplier code need to have grand total, can't balance to your input file need to have SupplierCode and SupplierLegacyCode

What report are you talking about here?

[davidonelson]

@ramildomingo the original post was edited to be clearer about what is needed.