Results 1 to 3 of 3

Thread: Pastel Partner SDK and Projects

  1. #1
    New Member
    Join Date
    Mar 2019
    Location
    Cluj-Napoca
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    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:	284 
Size:	61.6 KB 
ID:	7487

    Thank you,

  2. #2
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    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

  3. Thanks given for this post:

    QuickTrader (12-Mar-19)

  4. #3
    New Member
    Join Date
    Mar 2019
    Location
    Cluj-Napoca
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Great answer Kevin.
    Thank you!

Similar Threads

  1. [Question] Pastel Projects
    By Mel123 in forum Accounting Forum
    Replies: 0
    Last Post: 18-Jan-17, 12:08 PM
  2. Pastel: Moving expenses between Projects
    By TravisZA in forum Accounting Forum
    Replies: 1
    Last Post: 08-Mar-16, 01:17 PM
  3. [Question] Pastel xpress projects in purchase returns
    By Tanja Reinhardt in forum Accounting Forum
    Replies: 2
    Last Post: 23-Feb-16, 02:53 PM
  4. Pastel - Projects - Please Help
    By TravisZA in forum Accounting Forum
    Replies: 2
    Last Post: 03-Nov-15, 09:10 PM
  5. Pastel Xpress 12 Projects
    By xpressnewbie in forum Accounting Forum
    Replies: 0
    Last Post: 28-Mar-14, 06:43 AM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •