on 11-25-2008 12:29 PM
Greetings all!
I'm using SAP B1 2005A and I have a code that automatically creates A/R invoices based on delivery notes. Is there a way to get the invoice total before the invoice is added to the company database? The problem is I do not include all items from a processed delivery when creating an invoice so I cannot use the delivery total in this case.
Regards, Yavor
Yavor,
You need to add the document (invoice) before you can use fields like DocTotal. Only thing that might work is create a concept document, and get the DocTotal from that document.
regards,
Winfried Tiemessen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Winfried!
Thanks for the answer - will try to use the draft though i must remove it after I'm done with it for I wouldn't unnecessary drafts to pile up.
Regards, Yavor
PS: I think that ODLN.PaidToDate field should do just fine. It seems that ODLN.DocTotal - ODLN.PaidToDate returns the sum that is not yet processed in the corresponding delivery.
Edited by: Yavor Naumov on Nov 25, 2008 7:46 PM
User | Count |
---|---|
93 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.