AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • 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)

Dan Wilkins
Dan Wilkins
@dwilkins
Forum Home   |   Recent Posts
Eminent Member
Follow
Profile Activity
Topics: 6 / Replies: 13
AllTopicsReplies
Reply
RE: Generic Inquiry using Parameters with Inventory Attributes

Originally, I wanted to use Item attributes of the multi-select combo type where you could select multiple attributes from the GI parameter attribute....

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Product Configurator - GI Inventory Item List with Attributes as parameters

Thanks Tim. My findings are taking me to these same results.

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Attribute assignment to Inventory Items via Generic Inquiry through Mass Update Fields

Vote it up ! Assign attributes to Inventory Items through the Mass Record Update in Generic Inquiry | Community (acumatica.com)

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Generic Inquiry using Parameters with Inventory Attributes
5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 2
Views: 2764
Reply
RE: Product Configurator - GI Inventory Item List with Attributes as parameters

OK, Thanks Daru. Any input is appreciated.

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Product Configurator - GI Inventory Item List with Attributes as parameters

Yes, but the attributes are not text but multi select combo boxes. I don't want these in the columns of the GI, just as parameters at the top of the G...

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Product Configurator - GI Inventory Item List with Attributes as parameters
5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 6
Views: 1635
Reply
RE: Attribute assignment to Inventory Items via Generic Inquiry through Mass Update Fields

This would be faster than having to do it through a import scenario.

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Attribute assignment to Inventory Items via Generic Inquiry through Mass Update Fields
5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 5
Views: 1164
Reply
RE: Sort by and IIF Functions

For my doc total in Invoice our GI, I use the following in the data field: =IIf([ARInvoice.DocType]='CRM', [ARInvoice.CuryOrigDocAmt]*-1, [ARInv...

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Default Vendor for an Item

Like in Quantum Entanglement, it's in a superposition 👍

5 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Best Practice ideas for designing a dynamic naming convention for subaccounts
6 years ago
Forum
Everything Else
Replies: 1
Views: 1227
Topic
Primary key list for each DAC Table
6 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 1
Views: 2742
Reply
RE: Inventory List GI including Sales Price, Avg Leadtime, Last Cost, Vendor Cost, Last PO, and Last PR Receipt

Thx for the input. I thought I had gone back and done that.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Inventory List GI including Sales Price, Avg Leadtime, Last Cost, Vendor Cost, Last PO, and Last PR Receipt

Here you go. Please note that in the results grid below the column with Caption "Last 2 Yr Sales" is showing inflated QTY's. I am working on gett...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Inventory List GI including Sales Price, Avg Leadtime, Last Cost, Vendor Cost, Last PO, and Last PR Receipt

Thx! It's working now. Attached are screen shots if any one wants to use as reference.

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Inventory List GI including Sales Price, Avg Leadtime, Last Cost, Vendor Cost, Last PO, and Last PR Receipt

Thank you Shawn for the input. This will work but the results only include items with Purchase Orders against them. Because of this, is why I headed ...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Inventory List GI including Sales Price, Avg Leadtime, Last Cost, Vendor Cost, Last PO, and Last PR Receipt

Thank you Shawn for the input. Because I do not want Purchase Orders to show that begin with PO(Capitalized Letter O) and just Purchases Orders begin...

7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Topic
Inventory List GI including Sales Price, Avg Leadtime, Last Cost, Vendor Cost, Last PO, and Last PR Receipt
7 years ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Replies: 13
Views: 4484

Online Members

  • Dianne A Julie Baker
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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