| Docs Help
  AppSource  
Docs  /  NCCA Cost Accounting  /  Journals  /  Service Allocations

Import Service Allocation Journal


2023/05/19 • 2 min. to read
In the Service Allocation Journal, journal lines can be imported from a file (action Import from File) or from an Excel file (action Import from Excel). This can be used, for example, to transfer postings from other systems.

File structure

The field separator is assumed to be tab when importing from a file. A header line (e.g. line with field names) is not allowed when importing from a file. However, the Excel sheet can optionally contain a header row. In this case you will get a hint when importing the Excel file and you can import the data starting from the 2nd row.

Tip

The Create Excel Workbook for Import action in the Journals can be used to create an Excel workbook that can be used as a template for importing journal lines.

Field order

  1. Posting Date
  2. Document No.
  3. Work Type Code
  4. Credit Cost Type Code
  5. Debit Cost Type Code
  6. Quantity
  7. Price
  8. Amount
  9. Description
  10. Reason Code
  11. Credit Cost Dimension 1 Code
  12. Debit Cost Dimension 1 Code
  13. Credit Cost Dimension 2 Code
  14. Debit Cost Dimension 2 Code
  15. Credit Cost Dimension 3 Code
  16. Debit Cost Dimension 3 Code
  17. Credit Cost Dimension 4 Code
  18. Debit Cost Dimension 4 Code
  19. Credit Cost Dimension 5 Code
  20. Debit Cost Dimension 5 Code
  21. Credit Cost Dimension 6 Code
  22. Debit Cost Dimension 6 Code
  23. Credit Cost Dimension 7 Code
  24. Debit Cost Dimension 7 Code
  25. Credit Cost Dimension 8 Code
  26. Debit Cost Dimension 8 Code

Note

If Price and Quantity are specified in the file, the amount is determined automatically. In this case, the amount is read from the file only if the quantity times the price is 0.


Submit feedback for
DE|EN Imprint
<>