Steps for importing invoices

[Former Member]

Hi,

This is the first time i am importing invoices in SAP-B1.

Can anybody guide me how to go ahead with this step by step.There are 2 templates one is document and the other is document lines.how to define the link between these two templates?

I am using segmentation accounts.Can i use the format code in the account code field?

If i want to upload as service invoice,what do i need to do?

Please help.

Thank You

Regards

Md.nazeer Shaikh

[former_member187989 · Accepted solution]

For record key 1 LineNum should be from 0,1,2 .

Jeyakanthan

[former_member187989]

hi,

Record Key is link between Document & Document_Lines template.

In Document Template

Enter RecordKey,CardCode,DocDate,DocType(dDocument_Service),Series(mention series no. if you want to assign document number)

In Document_Lines template,

Enter RecordKey,LineNum,Account Code(segmented a/c code),TaxCode,LineTotal

Also refer to link

If there is doubt/clarification let me know.

Jeyakanthan

[Former Member]

Hi Jeykanthan,

Thanks for the guidelines.

If there are 3 document lines in one document in that case the record key should be the same????

for example if record key 1 in document template has 3 lines does that mean i should assign record key 1 in document lines template 3 times for line 1,2 & 3

is it like this?

Please correct if i am wrong

Thank You

regards

md.nazeer

[Former Member]

Hi Nazeer,

If you want to import A/P Invoices, you can use the oPurchase invoices template and for the A/R invoices, you can use oInvoices template.And as in your case that you said that you are using segmented CoA, you can use OACT in the query generator to get the account in the format _SYS00000000xxx .Hope this helps.

Best regards,

Joseph