shipment sales amount v's invoice sales amount

(1) Share

Report

Posted on by WM-10122352-0

Hi,

We've had a shipment posted with a different month to the actual invoice. The invoice was reversed but it's put a sales amount at a different month under the item code (see below). The G/L all looks fine from a income statement and receivables, but the item stock levels have transactions across two months which means my end of month count is incorrect.

ie the inventory was reversed on invoice date reversing v's the shipment date reversing. I obviously need the sales to reverse on the posted date but need to inventory reversal to match the shipment date. I've tried an item journal - which seems to get the item quantities correct but it still leaves the sales amount (actual) in the item ledger out.

any suggestions

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (1)

WM-10122352-0 7 on at

Like (0)

Report

shipment sales amount v's invoice sales amount

thank you very much. i've done in a test environment and works. Now to put into production.
Verified answer

Yi Yong 1,647 Super User 2024 Season 2 on at

Like (2)

Report

shipment sales amount v's invoice sales amount

Hello,

If you need the return shipment and the credit memo to be a different date then you should not create a sales credit memo directly.

Instead, you will need to create Sales Return Order and post the return shipment with posting date as the shipment date.
Then, post credit memo from the Sales Return Order with posting date as the invoice date.

For now, if you want to correct this credit memo, you will need to issue a sales invoice with the same data as the sales credit memo to contra them.

Then perform the above mentioned steps.