Skip to main content
Solved

Rate Tables issue

  • January 16, 2025
  • 1 reply
  • 104 views
H
Semi-Pro II
Forum|alt.badge.img
  • Harry
  • Semi-Pro II
  • 271 replies

Hello all,

I have been working on Rate tables for Project module and have defined some rates for lets say Project A & Project B for Employee 1 & 2.

The rates setup are as :

  1. Start Date: 01/01/2024; End Date: 12/31/2024; Rate: 10$; Project ID: Project A & B; Employee ID: 1
  2. Start Date 01/01/2024; End Date: 12/31/2024; Rate: 20$; Project ID: Project B; Employee ID: 2

Now I am looking to import new rates for the year 2025. So the scenario would be:

  1. Start Date: 01/01/2025; End Date: 12/31/2025; Rate 15$; Project ID: A ; Employee ID: 1
  2. Start Date: 01/01/2025; End Date: 12/31/2025;; Rate: 25$; Project ID: B; Employee ID: 1.

Eventually when I am trying to create a new rate code for the 2025 scenario, Acumatica displays an error stating the Rate Code, Project ID & Employee ID has already been used. Now if I go ahead to delete the 2024 Rate Code and try to create for 2025, it doesnt trigger any error. How can I insert both 2024 & 2025 rates with different rate codes?

 

Best answer by harshitasethia74

Hey ​@Harry ,
Can you try creating a new sequence under Rate Lookup Rules screen. It will work.

1 reply

H
Varsity I
Forum|alt.badge.img
  • harshitasethia74
  • Varsity I
  • 18 replies
  • Answer
  • January 17, 2025

Hey ​@Harry ,
Can you try creating a new sequence under Rate Lookup Rules screen. It will work.


Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved