AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Import Scenario for...
 
Notifications
Clear all

Questions Import Scenario for AP Debit Adj & AR Credit Memo with Application by a custom key

 
Everything Else
Last Post by Tim Rodman 5 years ago
2 Posts
2 Users
0 Reactions
1,370 Views
RSS
jentran
Posts: 6
 jentran
Topic starter
March 2, 2021 12:24 pm
(@jentran)
Active Member
Joined: 6 years ago

I have a client that has high volume of AP & AR transactions from an external system.  They want to import them even when it's not finalized to show up in their aging so that creates a dilemma when we need to reverse out the estimate and replace with final transaction.  Ideally we would do the accrual in GL but they don't want to.  It's crazy but that's what they want. So I need to create an import scenario for AP Debit Adj & AR Credit Memo with application.  First issue is i can't seem to get AP Bills screen to take the application document. Has anyone been able to successfully apply a Debit adj to a bill via import scenario or even on screen in the Bills & Adjustment Screen? 

Second issue I have is...the application document has to look up by by vendor ref and customer order field respectively because the Bill and Invoice Ref Nbr isn't available in the data since it's coming from an external system.  Does anyone know how to look up the application doc ref nbr using a custom key (vendor ref/customer order nbr)?  I tried the @@InvoiceNbr but doesn't seem like it would work the field isn't available in the application object to map to.

Any help would be greatly appreciated.

 

 

 


1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
April 21, 2021 11:00 pm
(@timrodman)
Famed Member
Joined: 11 years ago

Hi @jentran,

 

I recommend posting this in the new official Acumatica Community Forums:
https://community.acumatica.com

 

For the foreseeable future, the Forums here will focus on the Reporting Tools in Acumatica (Dashboards, Generic Inquiries, Report Designer, ARM Financial Report Writer, Velixo, Excel, Power BI, etc.) and also discussions that are too “transparent” to be allowed in the new official Acumatica Community Forums. For more info about how AUGForums.com compares to the new official Acumatica Community Forums, checkout this post:
https://www.augforums.com/augforums-com-vs-the-official-acumatica-community


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 11 Online
  • 2,420 Members
Our newest member: Katerina Pawlowski
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Tim Rodman
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×