Skip to main content
Question

Join Table Expense Claim with Available Cash Advance

S
Jr Varsity II
Forum|alt.badge.img

Hi community,

Need your help on how to join Table Expense Claim with Available Cash Advance for the particular employee in  EP612000 screen.

Thanks in advance.

 

Regards,

Iko

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3393 replies
  • March 13, 2024

@satwikh1 Can you please let me table names? or share the screenshots that you wanted to join the data?

Naveen B
Chris Hackett
S
2 people like this
  • Chris Hackett
    Chris Hackett
  • S
    satwikh1
S
Jr Varsity II
Forum|alt.badge.img
  • satwikh1
  • Author
  • Jr Varsity II
  • 14 replies
  • March 13, 2024

 @Naveen Boga, the table I used EPExpenseClaim with APRegisterReport / AP Payment where the advance created with Trans Type  “PPM”

S
Jr Varsity II
Forum|alt.badge.img
  • satwikh1
  • Author
  • Jr Varsity II
  • 14 replies
  • March 14, 2024

Hi @Naveen Boga,

here are the relationships table 

Vendor vs APregisterReport
APRegisterReport vs APPayment

 

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved