LS Retail Post G/L Entries Only!!

fahd
Member Posts: 226
Dear Experts,
My issue is related to LS Retail.
Normally in our case, if sales staff posts the statement after every day closing. So the system creates the entries in ICT Header for Stock as well as to create G/L Entries for that particular day.
I created new store with all the settings, some how i didn't properly setup the ICT and i made a mistake in ICT Setup.
Now, due to that mistake in the setup, When they posted the statement after closing the inventory is updated but it didn't create any G/L entry and ICT header table is already replicated to HO and has already updated the stock.
I want the G/L entries so that i could replicate to the HO and it should be updated in Chart of Accounts of HO for that store.
The problem is that statement is already posted in store, so i cannot recalculate it in store.
However if i calculate the amount in HO for that store those specific dates the data is getting calculated, but if i will post the statement again. It will make the inventory update as a negative (Sales Entries) for the second time in the Item ledger entry.
Is there any way that if i re-post the statements then it should only work on G/L entries and not the Stock.???
I just want to update the G/L not the stock, please let me know.
My issue is related to LS Retail.
Normally in our case, if sales staff posts the statement after every day closing. So the system creates the entries in ICT Header for Stock as well as to create G/L Entries for that particular day.
I created new store with all the settings, some how i didn't properly setup the ICT and i made a mistake in ICT Setup.
Now, due to that mistake in the setup, When they posted the statement after closing the inventory is updated but it didn't create any G/L entry and ICT header table is already replicated to HO and has already updated the stock.
I want the G/L entries so that i could replicate to the HO and it should be updated in Chart of Accounts of HO for that store.
The problem is that statement is already posted in store, so i cannot recalculate it in store.
However if i calculate the amount in HO for that store those specific dates the data is getting calculated, but if i will post the statement again. It will make the inventory update as a negative (Sales Entries) for the second time in the Item ledger entry.
Is there any way that if i re-post the statements then it should only work on G/L entries and not the Stock.???
I just want to update the G/L not the stock, please let me know.
0
Comments
-
Why dont you calculate the values and post a correction journal to G/L at Head Office?0
-
Thank you Kish
I followed the same way it's sorted out now.
Thanks again !0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions