Importing Automatic Charges (Lines)

(0) Share

Report

Posted on by SU-22040800-0

2,487

Is there an entity that i can use (even through excel import) to import automatic charges (lines)?

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello James,

For which element (purchase order, sales order, etc.) do you need to import those charges?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

qianwang 7,168 on at

Like (0)

Report
Copy link

Link copied!

Hi James,

There are some default data entities. Please check them.

Regards,

QianQW

Was this reply helpful? Yes No
SU-22040800-0 2,487 on at

Like (0)

Report
Copy link

Link copied!

Thanks Qjan

Was this reply helpful? Yes No
SU-22040800-0 2,487 on at

Like (0)

Report
Copy link

Link copied!

Hi Qjan

I'm struggling to get anything imported. I'm not sure what i'm doing wrong.

Do you have a sample import file that i can use?

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report
Copy link

Link copied!

Hi James Solomon

I suggest to create one record in the form. Afterwards export the entity and download the excel / package. Open the file and add all records you need. Based on the already available line you are able to see what fields are needed/filled. After that you can upload and import the package again.

Was this reply helpful? Yes No
SU-22040800-0 2,487 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply Christoph.

I have tried that already, but it is not working..

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report
Copy link

Link copied!

Hi,

what’s the error msg you are faced with? Please share some screenshots with the error.

Was this reply helpful? Yes No
SU-22040800-0 2,487 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply. This is the file that i attempt to import.. It is an export of a sample set, and then copy/paste

[View:/cfs-file/__key/communityserver-discussions-components-files/765/Book1.xlsx]

and this is the error i get when i try import it:

Was this reply helpful? Yes No
qianwang 7,168 on at

Like (0)

Report
Copy link

Link copied!

Hi James,

What data entity are you using? I open the excel you shared, however, it was found to be different from the entities "Automatic purchase document charges" and "Automatic purchase document line charges".

Why is 0 pending when you import it? Can you open "view staging data" to check?

Was this reply helpful? Yes No
SU-22040800-0 2,487 on at

Like (0)

Report
Copy link

Link copied!

Thanks Qjan - I'm using "Automatic purchase document line charges"

I checked the staging data, and it is blank ..

Was this reply helpful? Yes No