Announcements
Hi,
after I post PI in sales order, How can I track it .I can't find any table stored it, is it system standard function ,or controlled by parameters ?
Thanks.
Leo
*This post is locked for comments
Can u explain whas this PI in sales order , packing slip or invoice.
Regards
sorry for this, PI means profoma invoice here.
Regards.
When you post an proforma invoice, the tables CustInvoiceJour and CustInvoiceTrans and some others are temporary filled with the information for the invoice. The the Invoice will be printed and after the printing the records are deleted again. So the pro forma invoice is not stored in the database after all. If you want so, you can perhaps print the proforma invoice to the printing archive.
regards,
André
hi André,
Thanks for your answer.
How can I modify it to take it same as profoma Invoice in PO.
when we print the PI of PO ,one pending invoice will be generated and won't be deleted .
When using the PI of PO the system asks you to save the proforma invoice or not. When you confirm to save it, the information is kept in the tables PurchParmTable, PurchParmLine, PurchParmSubTable and PurchParmSubLine. In the table PurchParmTable the field ParmJobStatus has the value 'Waiting'. The From Pending Invoices will read data from these tables. Temporary tables are used to display it on the form.
So the best thing you can do is look how it is done at the purchase side and copy it to the sales functionality. When posting sales orders or packingslips or invoices the SalesParmTable, SalesParmLine, etc are used like the purchase side. This is also the case when using pro forma functionality, but normally the parm tables are deleted after pro forma printing.
great, Thanks André .
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 21
dserp 4
dekion 4
