Delete sales invoiced data from database these tables only

ahmedba · 2013-07-08

Hi guys IF i want to delete invoiced sales order then if i deleted from back end

i will deleted from these tables as following :

Sales Invoice Header

Sales Invoice Line

Customer Ledger Entry

Detail Customer Ledger Entry

G/l Entry

Are this as following True or False

Thanks

Savatage · 2013-07-08

Why do you need to completely erase the existence of an invoice & from the back end?

Isn't reversing the entry enough, else it looks like illegal activity is taking place.

Example/ You have an order for $1000.
Guy gives you $1000 in cash.
You wipe out any trace of this order & pocket the cash.

And what do you plan to do with all the inventory postings & value entries?

ahmedba · 2013-07-08

Why i told you I want to delete data from these tables because my case as following :

http://www.mediafire.com/view/myfiles/#lu9ggaceuejxxp2

I analysis the proplem i found it come as result to duplicate in Sales invoice No between two databases

Database A Database B

JE-PSI-008467 No JE-PSI-008467

JE-TC-002522 Customer no JE-TC-002552

When i make transfere data from database B to A it make this conflict so that in

Sales invoice header

JE-PSI-008467 JE-TC-002552 this after replaced

but true must be JE-PSI-008467 JE-TC-002522 because conflict happen because two orderes have same primary key in sales invoice header in No field

Sales invoice Line

JE-PSI-008467 JE-TC-002522

JE-PSI-008467 JE-TC-002552

How i remove this conflict so that my solution in above is to delete orderes come from Database B

from database A then modify it in B then import it again

So that How Can correct the proplem Now.

thanks

bbrown · 2013-07-08

So my question would be why are you moving the invoices between databases? If an invoice was posted in Database A, what business does it have in Database B?

Andwian · 2013-07-09

What is the main problem?

ahmedba · 2013-07-09

The main problem is Database B has same sales invoice no in database A
and after transferred from A to B it become sales invoice no replicate two times
and in sales invoice header table the record come from database B damage firstly order created because it has same no.
What i need here to make integration between two branches
How i solve problem of duplicate Now

bbrown · 2013-07-09

We understand what you are trying to do. The question is why? What is the business need/justification for this time and effort? Also, since you are havign 2 NAV databases should we assume you have a separate license for each? Or is the second database for reporting only?

ahmedba · 2013-07-09

Second database for reporting only and First database for transaction
and two database have developer license

bbrown · 2013-07-09

ahmedba wrote:

...two database have developer license...

Are you an end-user or a NAV Partner? If you are an end-user, do you just mean your NAV license contains some (or all) of the design granules? What is commonly referred to as "Developer Licenses" are actually NAV Partner license. They should NEVER be installed on a prodcution system.

If you are only doing reporting, why don't you look to some sort of data warehousing (BI) solution?

ahmedba · 2013-07-11

Can you told me if delete is only solution which tables i will delete from database
are this tables only
Sales Invoice Header

Sales Invoice Line

Customer Ledger Entry

Detail Customer Ledger Entry

G/l Entry
Or there are remaining tables

Delete sales invoiced data from database these tables only

Comments

Categories