AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

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

Royce Lithgo
Royce Lithgo
@roycelithgo
Forum Home   |   Recent Posts
Member
Follow
1 Followers / 0 Following
Profile Activity
Topics: 47 / Replies: 497
AllTopicsReplies
Reply
RE: Unit conversion is missing error in AP Bill processing

Did you check the Trace output under Tools menu?

4 weeks ago
Forum
Accounting in Acumatica
Reply
RE: Generic Inquiry to Export Scenario

XML doesn't need line breaks to be valid. Can you share the original XML if not confidential?

1 month ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry to Export Scenario

Have you tried an XML validator yet?

2 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry to Export Scenario

I was just thinking of whatever XML validator google search found. eg. But what about the log file mentioned in your 2nd screenshot? That might...

2 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry to Export Scenario

Click on the link in the error message that opens the log file. You need to work out what is wrong with the data in the excel xml file. There should b...

2 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Generic Inquiry to Export Scenario

Could you please screenshot the errors rather than attach the doc?

2 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Getting a SUM from Quantity on Report

I think you can just multiply the amount by the field InvtMult to get the correct sign. You should be doing a SUM of the formula that does the multi...

2 months ago
Forum
Acumatica Dashboards
Reply
RE: Adding multiple receipts to a bill error

It's not an issue from the application - the error message isn't in the source. Googling I found this:/p> It looks like an issue with your webserv...

2 months ago
Forum
Accounting in Acumatica
Reply
RE: Adding multiple receipts to a bill error

Try adding one by one and saving after each. Has your system been customised? I've never seen that error before.

2 months ago
Forum
Accounting in Acumatica
Reply
RE: Creating Import Scenario For Case History

You can't do anything in an Import Scenario that you cant do interactively in the page. So you need to find out how to do it interactively before atte...

2 months ago
Forum
Everything Else
Reply
RE: Formula comparing last created with ship date wont work

Try this:

2 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Formula comparing last created with ship date wont work

Try: =CDate([SOShipment.LastModifiedDateTime]) - CDate([SOShipment.ShipDate])

2 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Dashboard widget filter date range from single date parameter

I added the period start and end dates to the query result and then used a filter on those columns: This is actually better as it limits the resul...

3 months ago
Forum
Acumatica Dashboards
Topic
Dashboard widget filter date range from single date parameter
3 months ago
Forum
Acumatica Dashboards
Replies: 2
Views: 69
Reply
RE: Parameters in Scorecard KPI widget

Yep just had this issue today. So frustrating.

3 months ago
Forum
Acumatica Dashboards
Reply
RE: Appearance of Notes and Attachment action icons in query results

@ddunn I finally got around to testing this and unfortunately still no notes when Grouping is enabled. I even tried including the relevant NoteID in t...

3 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Join table with filter on a constant (Generic Inquiries)

You need to prefix the string with an equals so it's treated as a formula. ie. ='StatusB'

3 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

@anita-munnich what was the error?

3 months ago
Forum
Everything Else
Reply
RE: Import scenario - delete stock item conversion with IIF statement

Only way i can think of is 2 import scenarios, one for those with conversions and one for this without. Or depending on how many items need the conv...

3 months ago
Forum
Everything Else
Reply
RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Here's an excerpt from a Suppliers import that i did which assigned remittance account details. Hopefully it might be similar for what you are doing. ...

3 months ago
Forum
Everything Else
Reply
RE: Import Scenario for importing Cash Accounts including payment settings, remittance detail and entry types

Do you have a lot of cash accounts to import? This was one table that I've always configured manually as it didn't take long to do and building a GI w...

3 months ago
Forum
Everything Else
Reply
RE: Fixed Assets Question

Did you try the help? General: Depreciation Tab: So the one on the General tab is the default for the Class. On Depreciation it's the actu...

3 months ago
Forum
Everything Else
Reply
RE: Creating a report to automatically send for prior day and month

No, not possible. Put a checkbox parameter in the report which you tick in the schedule template. Then in the report criteria, where you apply the...

3 months ago
Forum
Acumatica Report Designer
Reply
RE: Linking Purchase Receipts with Closed Bills

You can't link Purchase Receipts to closed bills, so you'd need to reverse them if you desperately needed to do so. Purchase Orders can be closed a...

4 months ago
Forum
Accounting in Acumatica
Reply
RE: Help with grouping in a report

How about moving groupHeaderSection2, detailSection1 & groupFooterSection1 (which needs to be changed to footer of groupHeaderSection2) to a subre...

4 months ago
Forum
Acumatica Report Designer
Reply
RE: Is there a way to rearrange Header Sections?

No problem. Glad to hear that it worked for you!

4 months ago
Forum
Acumatica Report Designer
Reply
RE: Is there a way to rearrange Header Sections?

I don't think there is. You could try (carefully) modifying the child elements of <Sections> in the report .RPX file.

4 months ago
Forum
Acumatica Report Designer
Reply
RE: Activities (emails, messages etc.)

Try left join (POOrder to CRActivity) with this: POOrder.NoteID = CRActivity.RefNoteID

4 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Creating formula for GI

Try this: =IIf([IspkpCompanyOperatorLicense.EndDate] < DateAdd(Today(),'y',2), 'Expired more than 2 Years', IIf([IspkpCompanyOperatorLicense.EndD...

4 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: How to calculate weeks of supply

I doubt you can do it in GI as it requires calculations to be applied to aggregates and GI isn't good for that. You might need to migrate the GI to...

5 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: How to see who clicked "Approved for Payment" on an AP Bill?

There's a tab on Bills and Adjustments page named "Approval Details" - did you look there?

5 months ago
Forum
Everything Else
Reply
RE: Trying to subtract credit (amount) from sales dollars in a GI based on the ARTran table

How about this: =IIf([ARTran.DrCr] = 'D', -1, 1) * [ARTran.Amount]) This handles all tran types without having to specify them in the formula.

5 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Updating configuration option labels with import scenario

Not quite clear on what you're trying to accomplish but are you able to do the same update yourself interactively? Whenever I'm stuck with an IS I alw...

6 months ago
Forum
Everything Else
Reply
RE: Want to create a Generic Inquiry to manage files that are attached to sales orders

Unfortunately looks like the only way to join is via text in the UploadFile.Name field. Returns 1 row per attachment per sales order with atta...

6 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Sales Order Allocations disappear when a Shipment is confirmed - Bug or designed behavior?

Just recently noticed this as well but thought it was due to a recent change. Based on the age of this post it looks like it's always been that way.

6 months ago
Forum
Everything Else
Reply
RE: Want to create a Generic Inquiry to manage files that are attached to sales orders

Try joining SOOrder.NoteID to UploadFile.NoteID. UploadFileInfo has the filesize and datetime.

6 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: GI Last Execution Time/Date

Pretty sure it's not recorded. I am in the same situation with the custom GIs built at our site. Would also love to know who it was last run by.

6 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: IsPrimary field on contact not working in GI results

ps. don't forget to do a search before posting as someone else may have asked the same question.

7 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Export Invoice to PDF cuts off content

Problem is the size of the group is fixed - so it's clipping the field. Unfortunately you need to pre-allocate space for the note in the group. I've n...

7 months ago
Forum
Acumatica Report Designer
Reply
RE: Exclude Sales Orders where one line is a certain Inventory Item

Got it working - give this a go. Note that the data is returning at line level so if you want it at order level it needs Group criteria (as mine has...

7 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Exclude Sales Orders where one line is a certain Inventory Item

You have the COLOFEE filter on the wrong table (needs to be SOLine2). And you'll also need to join InventoryItem to SOLine2 to apply the filter on Inv...

7 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Exclude Sales Orders where one line is a certain Inventory Item

Try Left Joining an additional SOLine and use it to filter your main query. Join on ordertype, ordernbr and filter where inventorycd=colofee. Add ...

7 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Return Fields from Most Recent Record

@agupta I'm suggesting to write your GI based on selecting the data from the Item (POVendorInventory DAC). You won't be able to get the required outco...

7 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Return Fields from Most Recent Record

Pretty sure what you want to do above can't be done in GI for the reasons you encountered. Why don't you just take the price from the Item directly?...

7 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Slow Moving Inventory

Dead Stock does have Excel export button so you are mistaken there.

7 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Reply
RE: Importing a pipe delimited txt file

I think lack of header record is your issue - it's required AFAIK. You can add a header record with a command script and possibly replace the pipes...

7 months ago
Forum
Everything Else
Reply
RE: To add date (today) in the chart

@nsyafika What about a data table widget with only 1 row shown? You can include the date and the KPI value as the columns. It doesn't look as nice as ...

7 months ago
Forum
Acumatica Dashboards
Reply
RE: Customizer Access Rights

Customizer is required to publish. Access rights in the target tenant are controlled by user security in that tenant - they do not need Customizer rol...

8 months ago
Forum
Everything Else
Reply
RE: To add date (today) in the chart

I'm a bit vague on your requirements. If you want to include a calculated field as a Caption on a KPI (which is what you have circled in red), that un...

8 months ago
Forum
Acumatica Dashboards
Reply
RE: Boolean Field Values in Results Grid

Blank means false - are you certain there are Contacts where this property is true?

8 months ago
Forum
Acumatica Generic Inquiries & Pivot Tables
Page 1 / 11 Next

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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