Hi experts.
I have a 2 scenario, one for create sales order, second for create AR invoice.
When i create AR invoice, i wanna connect relationship map to sales order. How can i do this?
Thanks.
3 Answers
-
Best AnswerPosted on Jan 07, 2019 at 06:36 AM
Hello Amarjargal,
Relation Map is an SAP Business One feature.
You should open the B1 client and then you can use it.
The map displays the documents which built some connections.
When you created the Sales Order and AR Invoice, if you set the connection between them then you can see the expected map in relation map; otherwise, you cannot see it.
Based on my understanding, what you missed are something like "[BaseType]", "[BaseEntry]" and "[BaseLine]" which link the different type documents.
If you are not familiar with these, I would suggest you to refer DI help document.
Thanks & best regards
Huan Yang
Add comment
-
Former MemberPosted on Feb 18, 2019 at 04:58 PMHello Amarjargal Jargalsaikhan ,
1. While creating AR Invoice, if you have any sort of reference that is stored in SAP then you can use Call SQL atom to figure out the DocEntry of Sales Order.
2. Then using the Payload of the Call SQL atom, you can post the AR Invoice with BaseEntry, BaseLine, etc :)
In case, you don't have the reference while creating AR Invoice, then you should be creating both documents sequentially. If not, I'm afraid that you can't link the both documents. Else, if you are creating sequentially, then at the first scenario step handover the DocEntry to the next step by defining Successor at Outbound.
Add comment
-
Posted on Dec 24, 2018 at 08:48 AM
Dear Amarjargal,
Solution 1: If you base document is Sales order you can use Copy to functionality to create AR Invoice or if you are in AR invoice screen you can use the copy from functionality to fetch the data from base document. This process will automatically give you the Relationship map.
Solution 2: If you Crated two documents separately you can use reference document functionality to link both document together, this you can see in the relationship map by selecting the Referenced Document option. (Refer with the below attachment)
Note : In this case you have to close your sales order manually.
Add comment
Add comment