on 03-25-2019 2:41 PM
Hello:
In SAP Business One 9.3 PL06, I'm trying to modify the A/R Invoice in Crystal. I'd like to place the Purchase Order Number onto this report.
In what table will I find this?
Thank you!
John
Dear John,
Customer ref No already in table invoice.
the field name is numAtCard.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
to know about joins between tables in SAP B1 got o query generator and select both tables it will make auto joins form this you will know for simple and direct linked tables
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That's, actually, not what I was asking.
I cannot join any tables - period. Crystal is not letting me. How do I do this?
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
the relationship between two documents is in the lines, you have to use RDR1 for sales order lines, DLN1 for delivery lines and INV1 for invoice lines.
In each line, you can find the document father and the type of the document. And be careful because you can find a sales order line in several delivery lines, and the same with sales invoice lines.
Kind regards
Agustín
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please disregard. The "Customer Ref. No." field will be used.
I apologize, for the bother.
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi:
I'm sorry. But, I don't understand. Are you saying that a UDF has to be established, in order to have a field that will contain the PO Number?
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
If you convert one sales order in one sales invoice, you have 2 options: creating an UDF and copying the document number; or navigating through the invoice lines to the delivery lines, and then to the sales order lines and finally the sales order document.
If you convert several sales order in one sales invoice, you have to group the information by the sales order number.
Kind regards
Agustín
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
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.