Create Item AR Invoice to Service AR Credit Memo

[Former Member]

Hi Expert,

Customer is running 2007A PL30. We understanding that it is impossible to copy Item AR Invoice to service AR credit memo. It is customer business practice to issue same AR invoice to all customer for same item and later issue service AR credit memo to customer. Customer wants the item information to be copied to service AR credit memo rather than keying multiple rows to indicate discount given on which items. It is not possible to include discount at original AR invoice.

Any workaround or solution to solve this problem?

Regards

Thomas

[former_member583013 · Accepted solution]

Please note the following:

Item and Service type documents do not have a one to one match of the row level fields. So the ItemCode from the AR Invoice could not be copied to a AR Service CM as the ItemCode column is not exposed and these are 2 different types of documents.

This is what you could do....

Open the AR Credit Memo...Enter the Customer Code....

Add a formatted search to the Description field to Display the list of Items and take the Invoice number from the user as a parameter.

Query same below

SELECT T0.ItemCode FROM [dbo].[INV1] T0 INNER JOIN [dbo].[OINV] T1 ON T0.DocEntry = T1.DocEntry 
WHERE T1.CardCode = $[$4.0.0.] AND T1.DocNum = '[%0]'

[Former Member · Accepted solution]

Hi Suda,

Using SAP B1 8.82 PL6, can we copy from two AR Service Type Invoices to One Service Type AR Credit Notes? Is this a system limitations?

Thanks & Regards,

Vincent

[Former Member · Accepted solution]

Hi Chew,

This is the basic Functionality in SAP B1.

Go To A/R Credit Memo  Press Copy From Select A/R Invoice in Document Draw Wizard Please Check Customization press Next in that you will find the list of Possible A/R Invoice to be selected and follow the instruction from the wizard.

Regards,

Eshvanth

[Former Member · Accepted solution]

Hi Eshvanth,

Thanks for your reply. I can only select One Service Type Invoice on the Document Draw Wizard after checking on Customization. However, the intention is to Copy From more than One Service Type A/R Invoices. Understand that if it is Item Type A/R Invoices, I am able to perform that but not in Service Type.

Unless there is a limitation from Singapore Localization Set-up. Hope you are able to advise me from here. Thanks.

Regards,

Vincent Chew

[Former Member]

There is no work around to copy Item Type Invoice to service credit memo. You need to discuss with your customer to see how their business process can be more logical to be handled. If the Item type credit memo is not good enough for them, then the work around can be found from there.

Thanks,

Gordon