12

Often times a business requires accurate reporting on all shipped unbilled values in order to manage accrued A/R. Additionally, as a part of reconciliation requirements, reconciling the amount of Accrued A/R in the GL to the packing slip values/subledger is needed. Given the financial values of the sales are created at the time of the posting of the packing slip (first financial recording of a sales order), this is logically the place to gain this information. There is no current report for shipped unbilled values at a granular or detail level. Most will use the Open Sales Order Lines report and update query to Delivered status lines to achieve, however, in the Aged Balances section, there is a value present stating it represents the packing slip subtotal amounts, leading one to believe it would be representative of the true packing slip values by customer. However, the values of the packing slip subtotal amount not matching the value of the Packing Slip (GL Voucher value) because this subtotal amount in A/R Aging includes charges and tax which ARE NOT considered as a part of the packing slip voucher. Therefore there is no reconciliation which can be done to ensure the Accrued A/R and the packing slip total match. Having an additional field on the Related Information -> Credit fast tab in Aged Balances will better allow the company to have full visibility of actuals as they are written to the GL.



STATUS DETAILS
Needs Votes