x Want to participate? Join the group to interact
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 2 replies
  • Subscribers 15 subscribers
  • Views 929 views
  • Users 0 members are here
Browse Forums
Announcements
104
topics
4
replies
General Discussion
1k
topics
2k
replies
L Abrahams

Sage 200 Import Supplier Transactions

Posted By

Hi Everyone, 

Wondering if anyone can help please. We are importing supplier invoices into Sage 200, a single invoice will have multiple lines, so that we can see each line description in the nominal account. However in the Supplier account this invoice is not grouped, but shows as multiple lines with the same reference. 

Is there anyway to amend the import to stop this from happening, so the invoice groups within the supplier account with the same reference. but still split across each line in the nominal account

Thank you for any help. 

  • 0

    Yes, just add extra NominalAnalysis... columns, suffixed with /1, /2 - as many as you need.  You can do the same with the TaxAnalysis... columns if you need multiple tax codes.

    So your columns could be:

    AccountNumber
    TransactionReference
    SecondReference
    SYSTraderTranType
    TransactionDate
    GoodsValueInAccountCurrency
    TaxValue
    TaxAnalysisTaxRate/1
    TaxAnalysisGoodsValueBeforeDiscount/1
    TaxAnalysisDiscountValue/1
    TaxAnalysisDiscountPercentage/1
    TaxAnalysisTaxOnGoodsValue/1
    NominalAnalysisTransactionValue/1
    NominalAnalysisNominalAccountNumber/1
    NominalAnalysisNominalCostCentre/1
    NominalAnalysisNominalAnalysisNarrative/1
    NominalAnalysisTransactionValue/2
    NominalAnalysisNominalAccountNumber/2
    NominalAnalysisNominalCostCentre/2
    NominalAnalysisNominalAnalysisNarrative/2
    NominalAnalysisTransactionValue/3
    NominalAnalysisNominalAccountNumber/3
    NominalAnalysisNominalCostCentre/3
    NominalAnalysisNominalAnalysisNarrative/3

    This works for both Sales and Purchase ledger transaction imports

  • 0 in reply to Geoff Turner

    Thank you very much Geoff! This solves my problem. Many thanks! 

*Community Hub is the new name for Sage City