Pastel Partner SDK and Projects

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • QuickTrader
    New Member
    • Mar 2019
    • 4

    #1

    [Question] Pastel Partner SDK and Projects

    Dear TFSA community,

    Been using the Pastel Partner SDK for document import succesfully.
    Now I need to add a Project code to the Order lines. Is it possible?
    In which database file I can find the project's Code and Description fields?
    Also, in the DefineDocumentLine() function of the SDK i did not see a field that might contain the project code. However this code can be added from the Pastel Partner UI.
    Please see screenshot below:
    Click image for larger version

Name:	Capture3443.jpg
Views:	1
Size:	61.6 KB
ID:	269744

    Thank you,
  • Kevin Smith
    Silver Member

    • Aug 2018
    • 262

    #2
    The Project Codes used to be called cost codes - haven't been updated in the DB as far as I remember.
    Table - CostCodes
    Files - accjcode.dat
    Fields JobCode and JCDesc

    In HistoryHeader and HistoryLines you will be looking for "CostCode" - defined as CHAR with a size of 5
    Kevin Smith
    Sage Pastel Support Consultant
    KS Consulting
    www.ksconsulting.co.za

    Comment

    • QuickTrader
      New Member
      • Mar 2019
      • 4

      #3
      Great answer Kevin.
      Thank you!

      Comment

      Working...