Hey,
Sorry, you misunderstood my question, I'm not talking about reversing entries... let me clarify.. lets focus on account #3000. (stock A)
warehouse books the packing slip and amount makes a financial posting on #3000
financial department books invoice...amount from packing slip is reversed and amount on purchase invoice is booked on #3000
(even if the amount on the invoice equals the amount booked by the packing slip)
we now have +#3000 -#3000 +#3000 (not even mentioning the pre-calculated costs and the "cost" invoices)
Sales invoice books again -#3000. that is 4 times on #3000 resulting in 0 (we sell 99.99% back to back)
Open items on #3000 should show what the - unsold -stock is worth at any given time and which postings made this value!
for me to see which purchased goods have not been sold...I would appreciate the automatic settlement of #3000.
Please remember that freight,packaging,surveying etc etc are al precalculated and also make postings on #3000.
lets look at precalculated freight...packing-slip (goods received) +#3000, freight invoice -#3000 (amount packing-slip) and +#3000
precalculated insurance...same deal +#3000, -#3000 + #3000
precalculated Commission...same deal +#3000, -#3000 +#3000
So for a simple back to back purchase and sale I can have 30 postings on #3000. all resulting in zero, all postings show up on #3000 as open?
I think that account #3000 should only show (after I select - show open only) the value of the goods in stock, not what was bought and sold over the last X years.
This is just one example of ONE g/l account resulting in zero but still show all posting as open.
The system makes many system postings on G/L accounts... registering invoices/ approving invoices/recalculations currencies/closing inventory/ recalculation of vendors and customers accounts/ prepaid expenses/ ledger accruals, etc..... all resulting in ZERO.. why not settle these automatically?
Moreover these postings are often not visible while posting!
We buy and sell goods every day, we do not reverse postings every day...
Is our system not set-up correctly or is this a D365 thing? From the company that set-up our system I constantly hear:
None of the other customers, have problems with this- or - That's how D365 works...
My feeling is that D365 development has less and less to do with automatization and is not helping the end user.
Our yearly audit takes longer and longer the more is "automated"
Thanks for listening
