AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Everything Else
Reconciling AP to I...
 
Notifications
Clear all

Reconciling AP to IN after 2019.1 upgrade  

    Last Post
RSS

Royce Lithgo
Posts: 445
 Royce Lithgo
October 21, 2019 10:15 pm
(@roycelithgo)
Over 200 Posts
Joined: 10 months ago

We currently have a couple of GIs that I wrote which used UnbilledQty and UnbilledAmount of POReceiptLine to easily identify PO Receipts which hadn't been billed. 

With the (stupid) 2019.1 upgrade, UnbilledAmount is no longer available. I had a quick attempt to resolve this but wasn't able to. My current plan is to decommission my queries. The closest I've found is the Purchase Receipt Billing Details report, basically scanning the output and looking for rows where Billed Qty <> Receipt Qty. 

This is far from ideal. 

Does anyone else have a better way to do this under 2019.1?

4 Replies
Wyatt.ERP
Posts: 102
 Wyatt.ERP     ★★ All-Star ★★
October 23, 2019 12:43 pm
(@wyatt-erp)
101-200 Posts
Joined: 10 months ago

Have you considered using UnbilledQty/BilledQty and UnbilledAmt/BilledAmt on the POLine and comparing to OpenQty and UnitCost?  If you have receipts that do not start as a POLine, you are probably better off doing a join between APTran and POReceiptLine and comparing that way.  We bumped into some mess when we upgraded to 2019.R1 because of them removing these field too.  🙁

This post was modified 1 year ago by
Reply
Royce Lithgo
Posts: 445
 Royce Lithgo
October 23, 2019 5:43 pm
(@roycelithgo)
Over 200 Posts
Joined: 10 months ago

We have a mix of PO receipts and non-PO receipts. We basically need to recreate the old unbilled amount field from PO Receipts.

Reply
Tim Rodman
Posts: 2468
 Tim Rodman     ★★ All-Star ★★
December 4, 2019 9:40 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

I haven't worked with this yet, but I just noticed the Purchase Accrual Details (PO631000) report which uses a DAC called POAccrualStatus which looks interesting, especially the POAccrualStatus.ReceivedCost and POAccrualStatus.BilledCost fields.

image
Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 10 months ago

Over 200 Posts
Posts: 445
December 4, 2019 10:27 pm
Reply toTim RodmanTim Rodman

@timrodman

Yes we've noticed the new report and are using it to check open Purchases. It's a very handy report. Replaces the Purchase Receipt Accrual Details report but is improved by the fact that is has PO information as well. 

I've started to realise that with the 2019.1 upgrade, the purchase liability tracking has moved from receipts to purchase orders, which i guess makes sense in a way as the purchase order is where the liability started anyway. 

This post was modified 1 year ago by
Reply
Tim Rodman liked
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,645 Topics
7,641 Posts
5 Online
1,100 Members

Latest Post: Adding bill description on check stub Our newest member: thanh thuy Recent Posts Unread Posts

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×