cancel
Showing results for 
Search instead for 
Did you mean: 

Mass Import for Provision file

Former Member
0 Kudos

Hi Guys

I've recently strated working on SAP S4HANA Cloud, so i dont really master the tool yet 🙂 

My customer's accountants and management controllers generally work on each closing date with files containing all off of their provisions (generally one file per type of accounting provision).

  • NPF: invoices not received
  • FAE: the invoices to be issued
  • CCA: Prepaid expenses
  • PCA: Revenue recognized on advances

The customer wants to know, if this type of mass loading from Excel or .csv download, is available in S/4HANA Cloud ?

All advices or explanations are welcome !

Best regards

Accepted Solutions (1)

Accepted Solutions (1)

g_gregory
Discoverer
0 Kudos

The 'Upload General Journal entries' template also allows copying and pasting multiple header/line items to create one file with lots of Journal entries, including cross company (just don't forget to number them!). The 'Import Supplier Invoices' is also another favourite with a similar (but even easier) template. The importing of both of these is great - the persistent staging area is a dream.

For Customer Invoices you may need to get creative with the data migration import for open Sales Orders and then run a background job to convert to Billing Documents.

But it does depend on your requirements as Clare indicated.

Answers (2)

Answers (2)

former_member598943
Discoverer
0 Kudos

Hi TEAM

My User Team also requesting this option of Copying the Journal entries already posted as a new Journal Entry and post by change of date ,amount and all other Debit/Credit,Cost centers are same in S4H1808Cloud.

We have raised an Incident to SAP Support team to provide solution,team stated that this facility NOT available in S4H808cloud, suggested to use with excel file upload only.

former_member94298
Active Contributor
0 Kudos

Are you just looking to upload calculated values from excel as journals?

The 'Upload General Journal entries' app does precisely this - and you can edit the template structure so that you can load pretty much whatever detail you require on the line items.

I assume however that your requirement is more complex?