Find answers, offer solutions, ask questions
Please read: MYOB Advanced is now MYOB Acumatica
I'm excited that after 10 years of partnership with Acumatica we are finally merging our communities together! MYOB exclusively partners with Acumatica to bring MYOB Acumatica to Australia and New Zealand companies, as part of this we will be merging our communities to bring them closer together. Users should visit our MYOB product specific discussion board which you can find here to learn and ask questions. Remember to please use #MYOB tag so your fellow Aussie and Kiwi users can support you. Tags are key to helping other users engage with your post. MYOB has built out specific functionality to localise the platform for Australia and New Zealand, and we’ve also added Tags for that specific functionality. These are product functionality like Payroll, Workforce Management, Professional Services, Bank Feeds, Two Factor Authentication, or the MYOB Mobile. To get the fastest assistance from your local community make sure to use the MYOB specific tags, and post in this discussion board. We want to encourage being able to provide yourselves and your own clients the opportunity to leverage the ability to exchange insights, harness global knowledge, and collaborate at scale with a variety of likeminded users. Steps to Sign up: Acumatica Community Sign up Signing up is easy. Create a Username. Utilize your Work email address, full name and create a password. Agree to the Acumatica Terms and Privacy Policy. Click Sign up! To ensure MYOB Users can tell each other apart and assist one and other especially when it comes to our ANZ specific modules, it is important to utilize TAGs the wonderful Acumatica community have set up for us. Upon creating a Community post OR Product Idea as an MYOB User or Partner, please do utilize the TAGs that are relevant, you will see MYOB specific options. This way we know you’re a MYOB Partner. MYOB Acumatica customers will have direct access to global Acumatica forms, unlocking a global community with the ability to share insights and learnings from more than 22,000 users across the world (tagging features in the forums make it easier to connect with ANZ + global customers) making it a great opportunity to learn from the Acumatica Network, Connect and expand your own all while increasing visability of your own expertise and experience within the community. MYOB Advanced Business is now MYOB Acumatica. Today, we’re excited to expand our partnership with Acumatica, empowering our Australian and Kiwi customers with a global community.495Views1like0Comments
NZ Annual leave and averaging
Hi, A question about how the average rate is calculated for New Zealand annual leave. Our old NZ MYOB pay system (NZ Desktop) used to calculate the average rate by using the previous 52 weeks and working out the weekly average rate. I think this is considered section 8(1) of the Act, but don't quote me. Our new NZ MYOB pay system (Acumatica) uses the 52 week method AND the 4 week rolling average, and then selects the higher of the two averages. I think this is sections 8(1) and 8(2). Using this second method can create a huge difference in the annual leave rates. We employee regular set roster full time and regular set roster part time employees. Our employment contracts only mention we pay in accordance with the Holidays Act. Which is the correct method?
Bill Payment Cross Rate decimals inadequate
I have an issue where the cross-rate decimals is inadequate to clear the bill. A bill is created in Indonesian Rupiah. RP275,400,000.00 at a rate of 1AUD to RP 10,598.984. The AUD Equivalent is AUD 25,983.62. When the IDR bill is paid using an AUD Cash account, the Cross rate required is based on 1AUD to RP11016 = 0.000090777051561 AUD25,000 / 0.000090777051561 = RP275,400,000.00 However, in Acumatica there cross rate only allows up to 8 decimals, i.e. 0.00009078 The payment is AUD25,000/0.00009078 = RP275,391,055.30 That means that the balance on the Foreign currency bill is RP275,400,000 - RP275,391,055.30 = RP 8,944.70 which is AUD0.81 Although the payment of AUD25,000 is the final payment, the lack of decimals in cross-rate caused a remaining balance in the Bill. How can we pay the bill without any balance? Any workarounds?
MYOB Advanced - Accounts receivable with GST outstanding
Hi Community, I know this area is for MYOB business but can't seem to find an appropriate section for MYOB Advanced. I'm trying to run a report or find a work around so I can get the GST portion on outstanding receivables. Any help is appreciated. Thank you18Views0likes0CommentsFixes and Enhancements – MYOB Acumatica v2023.1.500
For those seeking some further detail on fixes and enhancements contained within the 2023.1.500 release (excluding Payroll), here's a run down: Finance: if a user signed in to an operating system with a locale that was configured with a comma as the decimal symbol and a period as the digit grouping symbol, and then the user entered a number in a box in the Summary area of a form and clicked any button, the comma was displaced 2 decimal places to the right of its intended position (for example, if the user entered 123,50, the value changed to 12350,00). Inventory and Order Management In a sales order with the Invoice, Credit Memo, or Mixed Order automation behavior, which is defined on the Template tab of the Order Types (SO201000) form, the values in the Unbilled Quantity and Unbilled Balance boxes on the Totals tab of the Sales Orders (SO301000) form were not updated to 0 after a Acumatica Release Notes for 23.118.0016 sales invoice was created and released for this sales order if the sales order had a zero Ordered Qty. On the Sales Orders (SO301000) form, when a sales order had multiple lines linked to drop-ship purchase orders, clicking the link in the Drop-Ship PO Nbr. column on the Details tab did not open the corresponding drop-ship purchase order on the Purchase Orders (PO301000) form. The same issue was with opening sales orders by clicking the links in the drop-ship purchase orders on the Details tab of the Purchase Orders form. On the Commissions tab of the Invoices (SO303000) form, the Commissionable Amount value was calculated incorrectly if a group discount configured for a customer was applied in a document that was prepared for the shipped sales order. The error occurred if the invoice was prepared for a sales order whose type had the Recalculate Discount on Partial Shipment check box selected on the Order Types (SO201000) form. If an item's quantity was greater than its Available for Shipping quantity in the specified location and Ship Complete was selected in the Shipping Rule column for this item on the Details tab on the Sales Orders (SO301000) form, a user could link this sales order to a shipment by using the Add Order button on the Details tab of the Shipments (SO302000) form and saving the shipment. If a sales order that collected taxes and was in the Back Order status in Acumatica ERP was modified in a Shopify store and then synchronized with Acumatica ERP, the connector failed the sync record for this order and showed the following error messages on the Sync History (BC301000) and Process Data (BC501500) forms: The following tax identifiers from the external system could not be matched: . The ERP has failed to save the tax ID or the tax amount differs from the one that has been expected. Make sure that taxes are configured for the tax zone and tax categories. Also, make sure that taxes either have the same identifiers in the ERP and external system or are mapped on the Substitution Lists (SM206026) form. This issue occurred if the Tax Synchronization check box was selected, the Default Tax Zone box was empty, and the Use as Primary Tax Zone check box was cleared in the Taxes section on the Order Settings tab of the Shopify Stores (BC201010) form. If an invoice was released for part of a sales order, the payment for the order was released, and then if the application was reversed on the Application History tab of the Payments and Applications (AR302000) form, users could not remove the payment from the order because of the error, which indicated that the Transferred to Invoice amount was not equal to 0. If a lot- or serial-tracked item was added to a return order by adding an invoice line on the Sales Orders (SO301000) form and then a partial receipt was created for that item on the Shipments (SO302000) form, the following error occurred when a user clicked the Confirm Shipment command: Item in invoice lot/serial number quantity returned is greater than quantity invoiced. System and Platform In the trace logs for any form, the company ID was empty for the long-running events. Simultaneous search for many values separated by a space in a drop-down list on any form could lead to a stack overflow exception and the restart of the instance. Fix Description: If there are more than 10 values to search for, the system takes only the first 10 values. If an action execution was selected as a subscriber on the Subscribers tab of the Business Event (SM302050) form, the system could not process this subscriber when the business event occurred and showed the following error message: Object reference not set to an instance of an object. In some cases, the statistics on the System Queue Monitor (SM302010) form were not displayed if multiple tenants were configured in the system. In rare cases, if two transactions were nested in each other and one of them failed, the system still saved the results of the other transaction in the database, potentially causing data inconsistency, which could include duplicate GL batches, shipment counter corruption, or a 200-status code response to the PUT CBAPI request with no entity created. Retail-Commerce The Shopify connector has been aligned with the Shopify API version 2024-01 to support instalment transactions for orders paid with the Shop Pay payment method. In some cases, when a Shopify order and its payment was imported to Acumatica ERP, the imported sales order was created on the Sales Orders (SO301000) form with the Tax Calculation Mode set to Tax Settings on the Financial tab, an incorrect order total, which included sales tax twice, and a nonzero unpaid balance. The issue occurred if the following conditions were met: o In the Shopify store, sales tax was set up to be included in product prices and shipping rates. o Avalara AvaTax was configured as the tax provider on the Tax Providers (TX102000) form. o On the Shopify Stores (BC201010) form, tax synchronization was enabled for the store and the Avalara tax zone was selected as the primary tax zone Integrations On the Shipments (SO302000) form, if a user shopped for rates by using the UPS Ground service method and increased the gross weight of the package beyond 50lbs, the following error occurred: UPS: Cannot deserialize the current JSON array (e.g. [1,2,3]) into type 'PX.UpsRestCarrier.Model.CodeDesc' because the type requires a JSON object. Service Management If the time zone on the user's computer was set to UTC+12, on the Staff Calendar Board (FS300400) form, the week numbers could duplicate in the Month view. In some cases, on the Service Orders (FS300100) form and on the Appointments (FS300200) form, when a user was adding a new line on the Details tab of the form, it took approximately 20 seconds for the system to load the information from the Inventory ID selector.141Views0likes0Comments
MYOB Advanced - Construction package
Hi We are about to pay a lot of money for the MYOB Advanced - Construction package. I can't see any reviews on it from actual businesses who are using it. We currently use the standard AccountRight. If your business uses this, can you please indicate your likes and dislikes of the package and anything else we should know. Thank you.945Views0likes7Comments
Novated Lease Payment - Set Up Account/Line Item
Hi Team, Our company recently had an employee set up with a Novated Lease arrangement, which is new to us and I don't have much knowledge about it. The Novated Lease is managed by a third party, and they send us a payroll advice and an invoice. Do I need to create a liability account on the balance sheet, for example, "2XXX-Novated Lease Clearing"? The payroll advice contains a pre-tax salary sacrifice amount. As I understand, this is different from superannuation salary sacrifice. Should I create a new pay item liability for this pre-tax salary sacrifice, with the ATO category being "Salary Sacrifice Other"? I assume this pre-tax salary sacrifice should then go to the GL Account 2XXX-Novated Lease Clearing, to clear out the balance sheet account. I would appreciate any help on this matter. Thank you so much.Solved2.5KViews1like4CommentsHow to Add Bank Details in Tax Invoice (Sales Invoice)
Hi everyone, We are currently implementing MYOB Advanced, and during our testing of the sales invoice, we noticed that the bank details are not appearing on the tax invoice. As a result, our customers are unable to make payments due to the missing information. Could you please advise on how to customize the sales invoice to include the bank details? Much appreciated! Best regards, Hazel Liu349Views0likes6Comments
Duplicate Application IDs in Bill Application Data Export via MYOB Advance API
Hello everyone, I've encountered an issue while exporting Bill Application data using the MYOB Advance API: some Application IDs are appearing twice. Has anyone else faced a similar issue, or does anyone have suggestions on how to resolve these duplicate IDs? Any help would be greatly appreciated! Best regards, EmmaMYOB Advanced API unexpected/unstable behavior
Hi all, I've just signed up here hoping someone can help me out with this issue that I am facing -- causing considerable integration problems which is not doing well for our customer -- who uses MYOB Advanced. The customer of course does not understand the issue as the essence of it is technical. I notice this happening randomly, and recently more often than not. Using the contract REST API, just trying to retrieve records randomly errors out with status 500 ( Internal Server Error ), and other times the request succeeds with a 200 ( OK ) but returns nothing, while I am Accepting and expecting JSON, my fetch client errors out, because the response body returned is not valid JSON, and the exact same request will sometimes succeed and return the expected results. I think it's best if I showed a video demonstrating this, so have a look at this: https://www.loom.com/share/1aad5298750e4d298b532ec746987964?sid=533f2a98-9057-48e0-bf0f-31223ffb2047 Can anyone experienced please tell me what this is about as to me it makes absolutely no sense?
ATO refund - MYOB Advanced
Have received a refund from the ATO. I am wondering do you enter via a cash transaction or enter via payables. If enter via payables how to do you close this out as there is nothing to offset against and as refund has been received don't want it deducted from the next quarterly payment. Thank you67Views0likes0Comments
