Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: dstramilov
- Order by date
-
Micros 3700 (Sybase) - SQL Query to record Sales to ERP
Any one can help with SQL query?- dstramilov
- Post #3
- Forum: Point of sale systems
-
Micros 3700 (Sybase) - SQL Query to record Sales to ERP
I got some queries views done already: 1. ALTER VIEW "Cognos"."Cost_Point_AJE"( /* view_column_name, ... */ ) AS SELECT a.Dates, a.Names, a.Counts, a.Amount, b.Revenue_Center FROM (SELECT v_R_rvc_trk.business_date "Dates", v_R_rvc_trk.ttl_name_01 "Names", v_R_rvc_trk.trk_cnt_01 "Counts"...- dstramilov
- Post #2
- Forum: Point of sale systems
-
Micros 3700 (Sybase) - SQL Query to record Sales to ERP
Hello, I need some help to write sql query that will generate Journal Entry by Revenue Centers (locations) that I can post to ERP. DEBIT: Cash Credit Cards(Visa, AX,MC,etc.) Discounts Gift cards redeemed Cash Short/Over Other... CREDIT: Revenue (broken by major group types, like...- dstramilov
- Thread
- Replies: 3
- Forum: Point of sale systems
